package com.yunze.common.mapper.mysql.bill;

import java.util.List;
import java.util.Map;

public interface YzBillsMapper {
    List<String> selDeptId(Map<String,Object> map);//根据deptid查询所有的 子级deptid
    List<Map<String,Object>> selBillByDept(Map<String,Object> dept); //根据dept查询 bill
    Integer selcountByDept(List<String> dept); //根据dept查询 bill
    List<Map<String,Object>> selBillByDeptAndMonth(Map<String,Object> map);//根据dept 和 month 查询 bill
    Integer selcountByDeptAndMonth(Map<String,Object> map);//根据dept 和 month 查询 bill
    List<Map<String,Object>> selBillByDeptName(Map<String,Object> map);//根据name 查询 bill
    Integer selcountlByDeptName(Map<String,Object> map);//根据name 查询 bill
    List<Map<String,Object>> selBillByDeptNameAndMonth(Map<String,Object> map);//根据name和month 查询 bill
    Integer selcountByDeptNameAndMonth(Map<String,Object> map);//根据name和month 查询 bill
    Map<String,Object> selDeptIdByDeptName(String deptName); // 根据dept_name 所在的 企业ID

    List<Map<String,Object>> getAll(Map<String,Object> map);//获取所有列表
    Integer selCountOne(Map<String,Object> map); //获取个数
    List<String> selPacketByOrder(Map<String,Object> map);
    List<String> selIccidByPacket(Map<String,Object> map);
    Map<String,Object> selUsedAndRemaining(List<String> list);
    Map<String,Object> selActiveCountInMonth(Map<String,Object> map);
    Map<String,Object> selNotActiveCount(Map<String,Object> map);
    Map<String,Object> selHaltCount(Map<String,Object> map);

    void inTable(Map<String,Object> map);

    List<Map<String,Object>> selPacketMap(Map<String,Object> map);
    List<String> selAlldept();

    List<String> selAllTid();

    List<Map<String,Object>> getPlist(Map<String,Object> map);

}
